/* ---------------------------------------------------------------------- */
/* Script generated with: DeZign for Databases vV7.0.1                    */
/* Target DBMS:           MS SQL Server 2005                              */
/* Project file:          Project4.dez                                    */
/* Project name:                                                          */
/* Author:                                                                */
/* Script type:           Database drop script                            */
/* Created on:            2012-03-21 18:06                                */
/* ---------------------------------------------------------------------- */


/* ---------------------------------------------------------------------- */
/* Drop foreign key constraints                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE [User_Account] DROP CONSTRAINT [Role_User_Account]
GO


ALTER TABLE [Answer] DROP CONSTRAINT [Question_Answer]
GO


ALTER TABLE [User_Quest] DROP CONSTRAINT [User_Account_User_Quest]
GO


ALTER TABLE [User_Quest] DROP CONSTRAINT [Question_User_Quest]
GO


ALTER TABLE [Role_Menu] DROP CONSTRAINT [Role_Role_Menu]
GO


ALTER TABLE [Role_Menu] DROP CONSTRAINT [Menu_Role_Menu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Role_Menu"                                                 */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Role_Menu] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [Role_Menu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "User_Quest"                                                */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [User_Quest] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [User_Quest]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "User_Account"                                              */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [User_Account] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [User_Account]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Menu"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Menu] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [Menu]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Role"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Role] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [Role]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Prize_Format"                                              */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Prize_Format] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [Prize_Format]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Answer"                                                    */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Answer] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [Answer]
GO


/* ---------------------------------------------------------------------- */
/* Drop table "Question"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Question] DROP CONSTRAINT 
GO


/* Drop table */

DROP TABLE [Question]
GO

